UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKA29IvrZU1+wv5ylfgWOl+pxogUQZINhSwUd9iumF8='
WHERE
key_id = 'eed2bfaa2836b588332d556b7b1488650b75fbb217ef80a34876abbc81ec455a'
AND (
token = 'lKA29IvrZU1+wv5ylfgWOl+pxogUQZINhSwUd9iumF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)