UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HphOTMjZPzAl/1++/b8SDvs+l5maHLeaVgC2iZRlOFg='
WHERE
key_id = '80b6fbc19c432e12b6c211cb10118894e81998036c21e9589f56cb44bcfb72ed'
AND (
token = 'HphOTMjZPzAl/1++/b8SDvs+l5maHLeaVgC2iZRlOFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)