UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnFboMPoVVFTaTqe2FEbAS2Msjf92RFxhGo/e2HAQHU='
WHERE
key_id = '5abb55a5749649475e8450ef4db9bd655a16e1c0d368c8cdba9af1791519a7b6'
AND (
token = 'JnFboMPoVVFTaTqe2FEbAS2Msjf92RFxhGo/e2HAQHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)