UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/+lZp8wJQnzuN08eCuubHRKCPwoXdi0G+WdKgl3R50='
WHERE
key_id = 'f3c807c396af15d3be9dec8b85a2476b4312819ed4565a3a6c03b184fdd12290'
AND (
token = 'N/+lZp8wJQnzuN08eCuubHRKCPwoXdi0G+WdKgl3R50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)