UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6DN6XP9QUPDzRgnYCa7BdbJOP11/zCGqoqldIbl9Q4='
WHERE
key_id = '674842742b5ffe5f9c7c9c4183e2bfe43d9368dec4d96f6d8ddd7c79be9fc6aa'
AND (
token = 'D6DN6XP9QUPDzRgnYCa7BdbJOP11/zCGqoqldIbl9Q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)