UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4BiQDeR2MA84bPSUT9cWyuPj4XKNd3xJkarD6z59zx4='
WHERE
key_id = '6904a61820ff45fad5bfeca011afc1021a864282337feb9c0a5e6456dc1ce4c8'
AND (
token = '4BiQDeR2MA84bPSUT9cWyuPj4XKNd3xJkarD6z59zx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)