UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5rmS3hgvqOvuDbB8+XRkGrrAEr/q3+5s8N7y1jbhCug='
WHERE
key_id = '30e097450b75d5b88bc56c607de1f00ab1dc2524f714c8586126cdaaa53fdf7a'
AND (
token = '5rmS3hgvqOvuDbB8+XRkGrrAEr/q3+5s8N7y1jbhCug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)