UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N3kLAAfDjpUC7670sbzsNeWiGjje1Fta/LbOz5mb5Pc='
WHERE
key_id = '8b0a7b55ce1411ab9f9df09034cc78f99449368df1d92c0e7c0553f3f2dcd19f'
AND (
token = 'N3kLAAfDjpUC7670sbzsNeWiGjje1Fta/LbOz5mb5Pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)