UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0jQiFmD9aPk73HSZJi0J77IEIHjJ25vEN27dLTkJ38='
WHERE
key_id = 'c579e2e6ec7c1e40c630c6457ee81d7484aab1f95306009a986a7ad3f23f3187'
AND (
token = 'U0jQiFmD9aPk73HSZJi0J77IEIHjJ25vEN27dLTkJ38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)