UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lh4n8EgNmivO0sJTcF997D4zxIS6GQjuponV6k/OYg4='
WHERE
key_id = '0381a6b475afe47a01c16f2188ff825d4190e472bab3af7770581c60ff34cd07'
AND (
token = 'lh4n8EgNmivO0sJTcF997D4zxIS6GQjuponV6k/OYg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)