UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zUtu7QC4pL0ZtqEE9Sj0IenlPDgy8Q8hSy4LjKhhQA='
WHERE
key_id = 'dea954ebcb1f3680990937013f253b2b9ae5687e19778990b09ca2ca3b638fea'
AND (
token = '8zUtu7QC4pL0ZtqEE9Sj0IenlPDgy8Q8hSy4LjKhhQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)