UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRCN2op18yv965LRG72lLiw7dq8A5ZuEsvxAADbaNEM='
WHERE
key_id = '565f4d2e577119f750f26da670d983247e78fcaf16285a4dbe7ec1309c6eaabd'
AND (
token = 'BRCN2op18yv965LRG72lLiw7dq8A5ZuEsvxAADbaNEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)