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