UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nJhYE03WU7KonQC1YrGVRo7RbkgIlTkashRj+F/jL4='
WHERE
key_id = '9f1da44e6604f3945f0c04b5f1de3a9f2cb3a5874e18066c804db4e93b0c730a'
AND (
token = '9nJhYE03WU7KonQC1YrGVRo7RbkgIlTkashRj+F/jL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)