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