UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAtlz5GA4g5XjOHJqFhZnhNnM0vzAccvGdFRz86ghis='
WHERE
key_id = '1e546b9f53f4c03ebb0f24b01dd17406041472ae36235b6d406927e2b27438b5'
AND (
token = 'HAtlz5GA4g5XjOHJqFhZnhNnM0vzAccvGdFRz86ghis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)