UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CFSA69Lo0yYiDx5QV5BoH7b2DG5NM2iUjIAGPhNiRF8='
WHERE
key_id = '6c4b2cbb294c0211c417023256726a3ceb8af01af66f61ae7d3b215ba8cb2330'
AND (
token = 'CFSA69Lo0yYiDx5QV5BoH7b2DG5NM2iUjIAGPhNiRF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)