UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KAKqe/KqczogMBsteib44dCBZNdbM83LwhsvqFd9Lw='
WHERE
key_id = '8c311197131cfdd9cd246e8190d32d3cfd4527a624dd9074453164d9c0514021'
AND (
token = '/KAKqe/KqczogMBsteib44dCBZNdbM83LwhsvqFd9Lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)