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