UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MHqozpDGD4ndjFuqEfAp3TZ3xjJhfhxhUVjx8U24fI='
WHERE
key_id = '7c9dd78863fb069be024cbe12a79a1def6a77ac9d4ad7eb030a08be6d1f94cdb'
AND (
token = '9MHqozpDGD4ndjFuqEfAp3TZ3xjJhfhxhUVjx8U24fI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)