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