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