UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hvTZl5kw/MGJQ3thkeccBdnjKvqCAJjC13VY8H+xhvs='
WHERE
key_id = '4ed77035a06262a23ee44a4762c2a956534dd219b2516f7b52671e4599b1d868'
AND (
token = 'hvTZl5kw/MGJQ3thkeccBdnjKvqCAJjC13VY8H+xhvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)