UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bW9qXAtfxGse7MAEYk9SCotxbf0RnzgE5v+wscxZnsc='
WHERE
key_id = 'e275528b6614c7aaf602de59dfd2a572d222ae67d80ffe0ffb408fe5b715848e'
AND (
token = 'bW9qXAtfxGse7MAEYk9SCotxbf0RnzgE5v+wscxZnsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)