UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mlbWRUU13/3Bu8M5LmZIf+QyD9634EZstW5h7cS1fJw='
WHERE
key_id = 'b992121ec019c58ffb1cf9bb06efde05e9599715cbc5796b49d6c1a2de242866'
AND (
token = 'mlbWRUU13/3Bu8M5LmZIf+QyD9634EZstW5h7cS1fJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)