UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lYZMgBMS4XfDJUVd8+UWzCqamqRz3hSZRz7gOuu14g='
WHERE
key_id = '6577509ad77b822ac7a723136502bfb7927eaeda059dbd79241a63933797766f'
AND (
token = '8lYZMgBMS4XfDJUVd8+UWzCqamqRz3hSZRz7gOuu14g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)