UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Xjbfe2ViOvsrK0+KLy9kxQYvnv4oygYi0ggfmVU5Q8='
WHERE
key_id = '3a218ad50a5d3b3de42e4f81f138185be744225fd71b21bac54df61e7ab83b55'
AND (
token = '8Xjbfe2ViOvsrK0+KLy9kxQYvnv4oygYi0ggfmVU5Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)