UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'unU07G1pv57vowK4xIWS3AgdfChxb6wwLiRVBmLymGw='
WHERE
key_id = '042af797498b630413a697445ec00127028618e8d7e3eaf0c913379470ba3986'
AND (
token = 'unU07G1pv57vowK4xIWS3AgdfChxb6wwLiRVBmLymGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)