UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MyohU+zYhpKyd1MM7TZXQI5SCKvXe1+5wmxcOefQTHc='
WHERE
key_id = 'd8db2182b2b3840e812ef7ff65d58c0aeff4570e6efb20e531646b81ace3d191'
AND (
token = 'MyohU+zYhpKyd1MM7TZXQI5SCKvXe1+5wmxcOefQTHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)