UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MycWmehZbqRC6rf+ctscRwNlaMoWP4Gk5kkKZse85l8='
WHERE
key_id = '2e1b3e307d6c8c6c6f25902ec96a3efb8bd4cdaea1c47305a830f607ca3b7bfc'
AND (
token = 'MycWmehZbqRC6rf+ctscRwNlaMoWP4Gk5kkKZse85l8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)