UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmyJJkbyP7PDKDAo51+xY3LMyRI2gMViuWqIoAlkZgE='
WHERE
key_id = '08e95ab2dac19d1fec1ec324117d42a1eccfa4a83da8971e6701c28d47f929a1'
AND (
token = 'ZmyJJkbyP7PDKDAo51+xY3LMyRI2gMViuWqIoAlkZgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)