UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W5nge1A9IHvLnnpqyQgFD53IfLPEG/uLJRM6IAj4RL8='
WHERE
key_id = 'f151f83754a44369d34b80439ea217ffb8dda87ce3cebcccba5b877bcbde13be'
AND (
token = 'W5nge1A9IHvLnnpqyQgFD53IfLPEG/uLJRM6IAj4RL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)