UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tF8dyaU1hZ7p9/8+DPu7Iq5skae/ujNZuMVqPI9MpuY='
WHERE
key_id = 'bb829e6021305bfb871b78fed6e6a00b46f2c372f05462116054561734a2a7d1'
AND (
token = 'tF8dyaU1hZ7p9/8+DPu7Iq5skae/ujNZuMVqPI9MpuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)